package com.athui.utils.explorer.strategy;


/**
 * @description: TODO Oracle 探查策略
 * @autor: zhangzhonghui
 * @create: 2024-08-02 12:30
 * @Version: 1.0
 */
public class OracleExplorerStrategy extends ExplorerStrategy {

    @Override
    public String sampling(Integer limit){
        return String.format("SELECT %s FROM %s SAMPLE(20) WHERE ROWNUM <= %d",super.getFields(),super.getFullTable(),limit);
    }

    @Override
    public String fullScan(Integer limit){
        return String.format("SELECT %s FROM %s WHERE ROWNUM <= %d",super.getFields(),super.getFullTable(),limit);
    }
}
